How to: Copy a chart to another sheet in the same workbook.
Solution:
Select the chart and select 'Copy' from the 'Edit' menu.
To copy a chart to another sheet within the same workbook:
1) Select the desired chart:
a) If the chart is embedded on the worksheet, double-click on the chart. (A striped border with handles appears around the chart.)
b) If the chart is on a separate chart sheet, click the tab for the chart sheet.
2) Select the 'Edit' menu and select 'Copy'.
3) Switch to the sheet to which the chart is to be pasted.
4) Select the location where the chart should appear.
5) Select the 'Edit' menu and select 'Paste'.
NOTE: The new copy of the chart remains linked to the original chart. Therefore, any changes to the original data will be made to both the original and the copied charts.
